IF EXISTS  
(      
SELECT 1      
FROM dbo.sysobjects      
WHERE id = OBJECT_ID(N'[dbo].[ChangeGoodsCode]')            
AND OBJECTPROPERTY(id, N'IsProcedure') = 1  )      
DROP PROCEDURE [dbo].[ChangeGoodsCode];


IF EXISTS  
(      
SELECT 1      
FROM dbo.sysobjects      
WHERE id = OBJECT_ID(N'[dbo].[SupplementaryInsurance_LoadDrugCondition]')            
AND OBJECTPROPERTY(id, N'IsProcedure') = 1  )      
DROP PROCEDURE [dbo].[SupplementaryInsurance_LoadDrugCondition];


IF EXISTS  
(      
SELECT 1      
FROM dbo.sysobjects      
WHERE id = OBJECT_ID(N'[dbo].[CopySupplementaryInsuranceDrug]')            
AND OBJECTPROPERTY(id, N'IsProcedure') = 1  )      
DROP PROCEDURE [dbo].[CopySupplementaryInsuranceDrug];





